package com.ruoyi.modules.mapper;
import java.util.List;
import java.util.Map;

import com.alibaba.fastjson2.JSONObject;
import com.ruoyi.modules.bean.LzUserLabel;
import org.apache.ibatis.annotations.Param;

import com.ruoyi.modules.bean.LzDepartment;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author zzw
* @description 针对表【lz_department(量子部门信息表)】的数据库操作Mapper
* @createDate 2024-05-28 11:02:17
* @Entity com.ruoyi.modules.bean.LzDepartment
*/
public interface LzDepartmentMapper extends BaseMapper<LzDepartment> {
    List<LzDepartment> getAllByDeletedOrderBySortDesc(Map<String, String> params);

    List<LzDepartment> getAllSonDept(Map<String, String> params);

    List<LzDepartment> getDepartmentScope(Map<String, String> params);

    List<LzDepartment> getUserDepartment(Map<String, String> params);

    List<LzDepartment> getAllParentDept(Map<String, String> params);
    List<LzDepartment> getParentDept1(Map<String, String> params);

    List<LzDepartment> getDeptByParentId(Map<String, String> params);

    Integer getCompanyCountByDeptId(Map<String, Object> params1);

    Integer getSmallPlacesCompanyCount(Map<String, String> params);
    Integer getUserCountByDeptId(Map<String, Object> params1);

//    查询部门下的所有子部门数量
    List<Map<String, Object>> getDeptCountByParentId(Map<String, String> params);

    List<LzDepartment> getStatisticsSelectData(Map<String, Object> params);
}




